Budget Driver

Overview

This driver is used for two major purposes:

1. Assign a driver statistic either to the facility or to an individual department.
• These drivers must exist in the Statistics sheet.
• The code requested is the same code that is in column A of the Statistic worksheet which is a combination of columns B & C in the Statistic worksheet.
• A red flag will indicate if an incorrect code has been input (refer to screen shot example).
2. Assign a default statistic to be used if a department does not currently have a database statistic.
• Departmental Exceptions from the facility assignment can be entered in the lower half of this sheet (refer to screen shot below).

The Driver sheet contains the following columns for each entity:

• BudgetGroup Code
• Department Description
• IP Driver
• OP Driver
• Default Statistic

Drivers must be defined in column A on the Statistics sheet in order to be used.

Settings

Open the driver, and complete the driver settings, as needed.

Video instructions